﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Common;

namespace TSCC.DataAccess
{

    /*for ItemA
     ('CALL OUT'			
    ,'客訴回電或處理'			
    ,'英/日語回電'			
    ,'各項業務追蹤(需經監控台同意)'			
    ,'警示帳戶'			
    ,'基金類') 
     */

    /*for ItemB
     * ('電腦/系統異常'
        '組長(區主管)約談/Coaching/跟聽'
        ,'專案執行'
        ,'安控檢查'			
        ,'跟聽新人/新人跟聽'			
        ,'其他')	
     */

    public enum ExceptionItem { ItemA, ItemB }

    public class DA_Exception:DA_Matrix
    {
        /// <summary>
        /// 取回全部
        /// </summary>
        /// <returns></returns>
        public DataTable GetException()
        {
            string sql = "SELECT * FROM [ExceptionItem] ORDER BY notempty";
            return getData(sql, "Exception");
        }        
    }
}
